Moving the columns from horizontal to vertical

[dankar]

ID	FIRST NAME	LAST NAME	DATE	PHONE#
1	ALLAN	SMITH	05/30/2019	4701325555

<tbody>
</tbody>

To become like this:

ID	1
FIRST NAME	ALLAN
LAST NAME	SMITH
DATE	05/30/2019
PHONE#	4701325555

<tbody>
</tbody>

Hi,

1. I have an excel file with over than 200 columns, I want to copy the heading to vertical position.

2. If possible also to copy the result also.

is there an easy way to do this. thanks

 

[Joe4]

This is pretty easy to do. Let's work with your example (and let's say the data is in cella A1:E2).
1. Select the entire range (A1:E2)
2. Select Copy (CTRL + C)
3. Select cell A3
4. Right-click, and select Paste Special --> Transpose --> OK
5. Delete rows 1 and 2

That's it!
It will work for 200 columns just as easily as it does for 5

 

[alansidman]

An alternative option is to bring the data into Power Query and unpivot the columns.

Here is the Mcode

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(Source, {}, "Attribute", "Value")
in
    #"Unpivoted Columns"

v	A	B
1	Attribute	Value
2	ID	1
3	FIRST NAME	ALLAN
4	LAST NAME	SMITH
5	DATE	5/30/2019
6	PHONE#	4701325555

 

[dankar]

Thank you all so much!

 

[Joe4]

You are welcome.