Notifications
Clear all
Excel Expert
2
Posts
2
Users
0
Reactions
107
Views
Topic starter
How can I convert a single column with multiple rows eg
13
15
16
17
to multiple column on single row eg
13 15 16 17
I know we can use the offset to convert multiple column to single column multi row - is it possible the other way around. A pivot table is not an option for me.
Thanks
Posted : 04/01/2019 10:43 am
Hi Alison,
You can use the Transpose function as explained here:
https://support.office.com/en-us/article/transpose-function-ed039415-ed8a-4a81-93e9-4b6dfac76027
Use OFFSET to get the range and then wrap it in TRANSPOSE.
Regards
Phil
Posted : 04/01/2019 6:40 pm
