merge data in multiple rows into one row

[Dana1]

Hi,I am trying to shorten a spreadsheet and make it easier to manipulate by putting travel records into one row. The way the data is displayed now is at least 3 and in some case up to 11 rows capture 1 record. The data deals with business trips. The travel code is what links each record and is the one identifier that is different. The rest of the data is traveler's name, title, date departed, location, date arrived, location, etc. each departure, location, and arrival are in a different row but the name, title, travel code all are repeated. I found the thread for "Bill asked this week's question about redundant Excel data" and tried using the =IF(A2=A1,C1 B2,B2) but it's not working. for one, it expects a calculation rather than for data to be moved from one cell to another. So my questions is: is there a similar formula that I can use where instead of actually specifying a cell I can ask if this is the first time "travel code" is encountered and it's the same is the next row, then move "x" data to a certain cell until the last of the same "travel code" is encountered?

 

[Dana1]

I figured most of it out, i just can't figure out how to delete the rows that I moved the data from. does anyone have any ideas on this?

 

[machopicho]

You have to use VBA

 

[Dana1]

thank you. I'm taking an online tutorial on VBA right now.