Is there a way to import horizontal data into Excel columns?

Question

If I have a file that is something like:

header1: 123, 122, 345, 66777
header2: 566, 766, 213, 3453

...

Is there a way to import it into Excel such that each row in the file becomes a column in Excel, or do I need to make some script to flip it first and just import it as a csv?

score 1 · Accepted Answer · answered Dec 04 '18 at 23:51

1

Use Power Query in Excel. Import the data into the Power Query editor, transpose it, then use first row as header.

answered Dec 04 '18 at 23:51

teylyn

33,024
3
50
68

There is something similar here: https://stackoverflow.com/questions/13174916/transpose-a-range-in-vba. You can refer to it and try to modify from it. – Raphael Lee Dec 05 '18 at 00:03

Is there a way to import horizontal data into Excel columns?

1 Answers1