how to align rows in excel?

Question

I have a large file containing materials inventory, but when downloaded into Excel, the location and quantity are in one sheet, and the description/part# is in another sheet. The PART ID and ID CODE columns are the only references to align descriptions and part numbers with locations and quantities. Please find a screenshot of the spreadsheet attached.

Thank you in advance.

Answer 1

Hello Tarciso, from what I can see here, this isn't an Excel issue. This is probably the way your inventory control system exports data. Aside from splitting the data into two sheets, I can also see that the table header spellings are a bit different and there's an additional "Price" column. Excel won't make all these changes to your file. Please check the inventory software settings to see if there's a way to export it all as one sheet.

Another option is to merge both sheets into one, eliminating the repeated columns. You can learn about combining Excel sheets here: https://support.microsoft.com/office/dd7c7a2a-4648-4dbe-9a11-eedeba1546b4.

• Stephen N.

Answer 2

files downloaded on the first Excel sheet (description and part numbers)

Answer 3

files downloaded on the second sheet (locations and quantities)

Answer 4

Hi Tarciso Tonani

Do you still need help with merging the two sheets?

Answer 5

No! All set! Thank you