Help - Dealing with data where each record takes 3 rows

CKO

New Member
Joined
Apr 30, 2007
Messages
9
Hi, I have a situation that is similiar to one listed in the Learn Excel from Mr Excel book, but slightly different.

I have groups of data, each taking up 3 rows. This is how they exported from another program. I need to move the data in row 2 and 3 into the last columns on row 1. Same with rows 5 and 6 need added to the last columns in row 4, etc...

Reading the instructions, I set up new columns A (Group) and B (Seq). I want to put a 1 in coumn A of every row where C has text. Then, I will want to put a 2 in column A of every row where K includes specific text (NPI) and I want a 3 in column A ov every row where K includes specific text (UPIN). The rows where I am looking at column K has data only in column K (C-J is blank).

My problem is, how do I get the 1 in column A when C has text?

Thanks for any help you can give!
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

CKO

New Member
Joined
Apr 30, 2007
Messages
9
Actually, I stated this wrong.

I want to end up with the first three rows all having a 1 in column A, a 2 in column A for the next three rows, a 3 in column A of the next 3 rows, etc... This will group 3 of the rows together with a unigue number for each group of three.

So, I need to look for text in column C, put a 1 in column A. Then, keep putting a 1 in column A of the subsequent rows, until I encounter text in C again. That row would put a 2 in column A of all rows, until I next encouter text in C, etc...
 

Forum statistics

Threads
1,181,056
Messages
5,927,864
Members
436,573
Latest member
CMR237

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top