Lining up multiple columns in excel

April 8, 2013 at 06:01:00
Specs: Windows 7
I have 4 columns in excel that that I am trying to match. I'm trying to get feb data and march data on the same lines so I can determine growth or decline for each individual item.
Currently the data looks like this:

BIKE $80 CAR $400
SHOW $10 BIKE $88
CAR $440 SHOW $6

I would like to match up all data to show like this:
BIKE $80 BIKE $88
SHOW $10 SHOW $6
CAR $440 CAR $400

There are new items coming on the list and dropping off the list all the time automatically when I run the original report, so when I download to excel it different every month. This being said if a new items comes on that is not in the previous month I would just like to see a blank or n/a, doesn't really matter.

I've tried VLOOKUP many times and can't get it to work.

Thanks in advance for the help.

See More: Lining up multiple columns in excel

Report •

April 12, 2013 at 12:18:55
I'm sure there may be better ways of doing this and this may only get you close but it should at least minimize the amount of work it takes to get them lined up.

Select one column header at a time (like column 'A' for instance) by clicking on the letter of the column to highlight the entire column. Then click the data tab and sort the current selection A-Z (without expanding it to encompass other columns).

This should at least get each column in alphabetical order. If the columns don't completely match up, you may need to right-hand click on the cell that doesn't have a match and click 'Delete...' then tell it to 'Shift Cells Up' and click ok. Hope this at least helps a little!!

Report •

April 12, 2013 at 12:58:02
Lets's say you start with this:

     A       B      C       D            
1   BIKE    $80    CAR    $400 
2   SHOW    $10    BIKE   $88 
3   CAR     $440   SHOW   $6 

Try this:

       A     B                  C                      D            
10   BIKE   $80  =VLOOKUP(A10,$C$1:$D$3,1,0)   =VLOOKUP(A10,$C$1:$D$3,2,0)
11   SHOW   $10
12   CAR    $440 

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question