Transpose information all into column A without losing cells

[kaplanj23]

I have a bunch of numbers and I want to transpose the numbers in other columns into column A. There is other information omitted from this sheet to keep it private the but the long short is that if there is data in b1,c1,d1,e1,etc1 then I need it to transpose directly under a1 and so on. is this possible to do automatically? Attached. Thanks

[Special-K]

Try this

Please Login or Register  to view this content.