Data Separation, Grouping and Combining

**DudeCampos** · 12-01-2020, 11:39 PM

Hi everyone,

I have a question regarding separating data that is grouped one after the other in rows.

For example, I have Product a single row followed by its Quantities in the row below it:

Product 1130174
Allocated Quantity: 0 G Rejected Quantity: 12 G
Product 1130175
Allocated Quantity: 0 G Rejected Quantity: 1 G
Product 1130124
Allocated Quantity: 0 G Rejected Quantity: 3 G

This goes on for quite a number of rows.

My 1st question is, how do I separate these rows into columns side by side so that I can find out which products are duplicates?
I would like to relate the quantities to the product but in a column format instead of the following row.

Any help would be very much appreciated.

Thank you.

**alansidman** · 12-02-2020, 12:24 AM

Are all values in one column? Cannot determine if there is more than one column or not.

Please read the yellow banner at the top of this page on how to attach a file.

**DudeCampos** · 12-02-2020, 12:54 AM

Originally Posted by alansidman

Are all values in one column? Cannot determine if there is more than one column or not.

Please read the yellow banner at the top of this page on how to attach a file.

Yes they are all in one column.

**alansidman** · 12-02-2020, 01:08 AM

With Power Query

Please Login or Register  to view this content.

Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

- Follow this link to learn how to install Power Query in Excel 2010 / 2013.

- Follow this link for an introduction to Power Query functionality.

- Follow this link for a video which demonstrates how to use Power Query code provided.

**DudeCampos** · 12-03-2020, 11:29 PM

Thank you alansidman, really appreciate the help, may seem like something small, but now power query has helped alot.

Data Separation, Grouping and Combining

LinkBack

Thread Tools

Rate This Thread

Display

Data Separation, Grouping and Combining

Re: Data Separation, Grouping and Combining

Re: Data Separation, Grouping and Combining

Re: Data Separation, Grouping and Combining

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Combining data in different rows into one cell, grouping by common data

DESPARATE NEED OF HELP: Separation of Addresses, Duplicates and Non Separation

[SOLVED] Combining duplicates and grouping unique values

Grouping of one pivot affecting the grouping and formatting of other pivots from Same data

[SOLVED] Combining multiple cells into one with comma separation based on item number

Combining or grouping tabs into one tab? Possible?

[SOLVED] Combining/Grouping Cell/Row information

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions