CheckEmoji Community · the emoji forum
🏠 Home 🆕 What's new ❓ Unanswered 🔥 Popular 📡 RSS Members 👥 0 online log in · register
Home › IT › IT Support › How to swap columns in a Word list?

How to swap columns in a Word list?

Started by restlessdrifter12 · · 👁 3 views · 4 replies

📡 Subscribe to replies

Participants restlessdrifter12Michelle Bennett5Sam Peterson6bluecyclist64
restlessdrifter12 restlessdrifter12 Active MemberOP
78 messages
joined Jun 2016
#1 ·
I have a Word document containing a list of about 1,000 songs—it currently looks like this:
Artist – Song
Artist – Song
Artist – Song
Artist – Song


But what I actually need is for the list to be formatted like this:
Song – Artist
Song – Artist
Song – Artist
Song – Artist


Is there any way to actually pull this off within Word itself?
Michelle Bennett5 Michelle Bennett5 Active Member
89 messages
joined Dec 2007
#2 ·
restlessdrifter12 said:I have a Word document containing a list of about 1,000 songs—it currently looks like this:
Artist – Song
Artist – Song
Artist – Song
Artist – Song


But what I actually need is for the list to be formatted like this:
Song – Artist
Song – Artist
Song – Artist
Song – Artist


Is there any way to actually pull this off within Word itself?

Honestly, you're probably better off just using Excel.
Copy the whole list over to Excel and it should land in one single column.
Just use the "Text to Columns" feature and set the delimiter to "-".
That gives you two separate columns, which you can then merge back together into a third one, just with the order flipped.
Use a formula like =song_column & " - " & artist_column

It’s overkill if you're only doing five songs, but when you're staring down a massive list, the manual work grows exponentially.
Sam Peterson6 Sam Peterson6 Member
37 messages
joined Aug 2021
#3 ·
I know there are definitely some apps out there that can handle that, I just can't wrap my brain around the names right now
bluecyclist64 bluecyclist64 Regular
369 messages
joined Oct 2011
#4 ·
restlessdrifter12 said:I have a Word document containing a list of about 1,000 songs—it currently looks like this:
Artist – Song
Artist – Song
Artist – Song
Artist – Song


But what I actually need is for the list to be formatted like this:
Song – Artist
Song – Artist
Song – Artist
Song – Artist


Is there any way to actually pull this off within Word itself?

First, select the entire list (Ctrl + A).
Go to Table -> Convert -> Text to Table.
Set the number of columns to 2.
Under "Other," type a hyphen (-) into the box.
Hit OK.

Now you should have a two-column table.

To swap the order, click at the very top of one column to select it, then just drag it over to the other side.

Select the first column and go to Table -> Insert -> Columns to the Right.

You'll end up with an empty column right in the middle.

In the first cell of that middle column, type " - ".
Highlight that cell and hit Ctrl + C.
Then, select all the remaining cells in that middle column (skip the first one) and hit Ctrl + V.

Click the top-left corner of the table to select the whole thing, then go to Table -> Select -> Table.
Navigate to Table -> Convert -> Convert to Text.
Choose the "Other" option and simply press the spacebar in the input box.
Hit OK.

And finally, the most vital part of the agreement: you owe me a drink next time we grab lunch!👍
restlessdrifter12 restlessdrifter12 Active MemberOP
78 messages
joined Jun 2016
#5 ·
Bravo, my friend—you hit the nail right on the head.
You’ve basically got a free lunch and dinner waiting for you in San Francisco next year, assuming Los Angeles FC manages to clinch the championship.

You must log in or register to reply here.

Log in Register

🔗 Similar threads