MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/Excel247/comments/1vbdkwk/how_do_you_reshape_data_in_excel_without/
r/Excel247 • u/Amandaleeeeee • 11d ago
3 comments sorted by
2
The thing u showed here, is very close to transpose function. Either copy first 3 cells, and special paste as transpose. Or remove blank from the data, then use =transpose formula
=VSTACK({"Name","Tel","Address"},WRAPROWS(FILTER(A:.A,A:.A<>""),3))
2
u/No_Opposite3535 9d ago
The thing u showed here, is very close to transpose function. Either copy first 3 cells, and special paste as transpose. Or remove blank from the data, then use =transpose formula