•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Moving values from Rows to columns
Please see the Screenshot attached
I have a large spreadsheet like this.
There is a mandarin word followed by the Pinyin, English and an example sentence all in rows.
This repeats for many different words. Each word has those same 3 accompanying values laid out underneath it in rows.
Is there a formula I can use to layout each word and its accompanying values in columns and repeat that for the whole document without copy and pasting Wraparrows loads of times.?
Example screenshot attached.
Note: screenshots taken in Googlesheets, but will use Excel.
10,000 words in total. 40,000 rows.
Have tried using AI, but it makes too many mistakes
Any help appreciated :). Am Losing my mind. :(
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com