V
VicV
I'm not sure how to ask the appropriate question to solve my problem.
One of my employees enter catalog numbers and quantities in an Excel
work sheet. It's a very big list and we needed the format to be one each
of the catalog number per line. What this person did was count the
number of units and put the catalog number and then put quantity on the
same line. I guess the best way to explain would be with an example.
What they did
Catalog No. Description quantity
2021 blue widget 3
2022 red widget 2
2023 green widget 1
What we actually need
Catalog No. Description quantity
2021 blue widget 1
2021 blue widget 1
2021 blue widget 1
2022 red widget 1
2022 red widget 1
2023 green widget 1
Is there a way with a formula or Macro to take the existing list and
change it to the desired result?
Thank You for any suggestions in advance.
VicV
***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
One of my employees enter catalog numbers and quantities in an Excel
work sheet. It's a very big list and we needed the format to be one each
of the catalog number per line. What this person did was count the
number of units and put the catalog number and then put quantity on the
same line. I guess the best way to explain would be with an example.
What they did
Catalog No. Description quantity
2021 blue widget 3
2022 red widget 2
2023 green widget 1
What we actually need
Catalog No. Description quantity
2021 blue widget 1
2021 blue widget 1
2021 blue widget 1
2022 red widget 1
2022 red widget 1
2023 green widget 1
Is there a way with a formula or Macro to take the existing list and
change it to the desired result?
Thank You for any suggestions in advance.
VicV
***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****