Combining values from multiple columns into one

**dylanvv** · 09-11-2014, 09:41 AM

I have a report that I had to run separately for each set of data I wanted. The data corresponds directly to the Item column I have. I have 5 Item columns with 1 or 2 columns of data that are associated with them. These item columns are more or less the same items and I just want to be able to get all of the data that corresponds with the item into one. I just want everything to match up with each other. Is there some sort of formula or function I can do that would accomplish this?

Columns.png

**natefarm** · 09-11-2014, 05:41 PM

These item columns are more or less the same items

From that, I'm assuming you mean that (15) AUTO BELT, (22) AUTO BELT, (24) AUTO BELT, etc., are all the same item. From your example, it appears that Qty on Hand, On Sales Order, Min, and Max values are all 0, Item Category Description is all blank, and the 5th Item column has all unique values. That just leaves the 4th set (Item/Vendor) to deal with. What I would do is:

1. Copy the 4th Item column to a new sheet in column A
2. Select column A, and on the Data tab, select Text to Columns
3. Delimit by ) and click Finish
4. Delete column A, which leaves you with your items in column A
5. Copy the Vendor column from the 1st sheet to the new sheet, Column B
6. Click Remove Duplicates and Ok.

If my assumptions about the other item columns in incorrect, you can probably figure out how to adjust the steps to include the remaining data.