Transpose Help

[ryerye77]

Hello,

I'm looking for some help with transposing a data set I have.

All the data is in one column like this....

Company 1

Address 1

City 1

Phone 1

Email 1

Company 2

Address 2

City 2

Phone 2

Email 2

Company 3

Address 3

City 3

Phone 3

Email 3

and I'd like to transpose it to rows without having to individually copy and pasting (transposing) each data set like this...

Company 1	Address 1	City 1	Phone 1	Email 1
Company 2	Address 2	City 2	Phone 2	Email 2
Company 3	Address 3	City 3	Phone 3	Email 3

I've been struggling with this for sometime now. Any help is greatly appreciated!

 

[63falcondude]

Try the following then drag it down and across.

=OFFSET($A$1,COLUMNS($A1:A1)-1+(ROWS($1:1)-1)*5,0)

Source: https://www.extendoffice.com/documents/excel/681-excel-change-columns-to-rows.html

 

[ryerye77]

AMAZING! Thank you so much 63falcondude! You are a wizard!

 

[63falcondude]

Glad to help!