Transposing like all into the same column

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
52,161
Office Version
365
Platform
Windows
it isn't a rocket science to translate things from Excel to GSheets (in case counterparts exist)
But sometimes they don't.

I would just recommend that if you have future questions that are going the same route, to just mention this up-front (that your intention is to move to Google Sheets).
You would hate to have someone spend a lot of time creating a VBA solution for you that you can't use (and they probably won't be too happy about it either!).
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Watch MrExcel Video

Forum statistics

Threads
1,090,142
Messages
5,412,704
Members
403,442
Latest member
keowinvip1

This Week's Hot Topics

Top