Hey everyone,
So I have a huge Excel document with each column containing some sort of data. Let’s say all of those data are contained in numerous rows in Columns A through D. What I want to do is take the data from each row from each column, add some extra text, and place it into Column E.
In the end, all of the rows should have a Column E with data from each of the columns for that row. I couldn’t find anything via searching the web either, so does anybody have any idea on how to go about doing that?
For example, here is how my spreadsheet looks like right now:
[COLOR=gray]Row 1 |[/COLOR] Foo : Zeeb : Zorb :
What I want is:
[COLOR=gray]Row 1 |[/COLOR] Foo : Zeeb : Zorb : Zorb and Zeeb went up the Foo
And there are numerous rows like that.It’s been a long time since I did that in a highschool comp class
Thanks,
Kirupa :bandit: