I have an excel document with 8000 + rows with 23 columns and desire to populate the UID column with a number with everything associatedwith that item (between row breaks). What formula can I use to populate the UID column automatically insequential order?(I’ve populated thedata shown below).
Column 1 UID, Column 2 ser #, Column 3 Item
[TABLE="width: 372"]
<tbody>[TR]
[TD="width: 100"]UID #
[/TD]
[TD="width: 93"]PKG_ID
[/TD]
[TD="width: 303"]DESCRIPTION
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]1
[/TD]
[TD="width: 93, bgcolor: transparent"]BOXRBATTERY
[/TD]
[TD="width: 303, bgcolor: transparent"]BATTERY STORAGE RM
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]1
[/TD]
[TD="width: 93, bgcolor: transparent"]C115529117
[/TD]
[TD="width: 303, bgcolor: transparent"]BATTERY (K)
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]1
[/TD]
[TD="width: 93, bgcolor: transparent"]C082732718
[/TD]
[TD="width: 303, bgcolor: transparent"]BATTERY (4)
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]1
[/TD]
[TD="width: 93, bgcolor: transparent"]C115529133
[/TD]
[TD="width: 303, bgcolor: transparent"]BATTERY (B)
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]1
[/TD]
[TD="width: 93, bgcolor: transparent"]C115529164
[/TD]
[TD="width: 303, bgcolor: transparent"]BATTERY (3)
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"][/TD]
[TD="width: 93, bgcolor: transparent"][/TD]
[TD="width: 303, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]2
[/TD]
[TD="width: 93, bgcolor: transparent"]9480968
[/TD]
[TD="width: 303, bgcolor: transparent"]TRUCK
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]2
[/TD]
[TD="width: 93, bgcolor: transparent"]PO9480968
[/TD]
[TD="width: 303, bgcolor: transparent"]RADIO
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"][/TD]
[TD="width: 93, bgcolor: transparent"][/TD]
[TD="width: 303, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]3
[/TD]
[TD="width: 93, bgcolor: transparent"]9480967
[/TD]
[TD="width: 303, bgcolor: transparent"]TRUCK,UTILITY
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]3
[/TD]
[TD="width: 93, bgcolor: transparent"]PO9480967
[/TD]
[TD="width: 303, bgcolor: transparent"]RADIO
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"][/TD]
[TD="width: 93, bgcolor: transparent"][/TD]
[TD="width: 303, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]4
[/TD]
[TD="width: 93, bgcolor: transparent"]9480965
[/TD]
[TD="width: 303, bgcolor: transparent"]TRUCK
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]4
[/TD]
[TD="width: 93, bgcolor: transparent"]PO9480965
[/TD]
[TD="width: 303, bgcolor: transparent"]RADIO
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]4
[/TD]
[TD="width: 93, bgcolor: transparent"]5127431
[/TD]
[TD="width: 303, bgcolor: transparent"]FLOODLIGHT
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]4
[/TD]
[TD="width: 93, bgcolor: transparent"]5127809
[/TD]
[TD="width: 303, bgcolor: transparent"]GENERATOR
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"][/TD]
[TD="width: 93, bgcolor: transparent"][/TD]
[TD="width: 303, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]5
[/TD]
[TD="width: 93, bgcolor: transparent"]9480963
[/TD]
[TD="width: 303, bgcolor: transparent"]TRUCK
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]5
[/TD]
[TD="width: 93, bgcolor: transparent"]PO9480963
[/TD]
[TD="width: 303, bgcolor: transparent"]RADIO
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"][/TD]
[TD="width: 93, bgcolor: transparent"][/TD]
[TD="width: 303, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]6
[/TD]
[TD="width: 93, bgcolor: transparent"]3460954
[/TD]
[TD="width: 303, bgcolor: transparent"]TRUCK
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]6
[/TD]
[TD="width: 93, bgcolor: transparent"]PO9480954
[/TD]
[TD="width: 303, bgcolor: transparent"]RADIO
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]6
[/TD]
[TD="width: 93, bgcolor: transparent"]9504639
[/TD]
[TD="width: 303, bgcolor: transparent"]CLEANER,STEAM
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"][/TD]
[TD="width: 93, bgcolor: transparent"][/TD]
[TD="width: 303, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]7
[/TD]
[TD="width: 93, bgcolor: transparent"]6770953
[/TD]
[TD="width: 303, bgcolor: transparent"]TRUCK
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]7
[/TD]
[TD="width: 93, bgcolor: transparent"]PO9480953
[/TD]
[TD="width: 303, bgcolor: transparent"]RADIO
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]7
[/TD]
[TD="width: 93, bgcolor: transparent"]5126126
[/TD]
[TD="width: 303, bgcolor: transparent"]FLOODLIGHT
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]7
[/TD]
[TD="width: 93, bgcolor: transparent"]5127159
[/TD]
[TD="width: 303, bgcolor: transparent"]GENERATOR
[/TD]
[/TR]
</tbody>[/TABLE]
Column 1 UID, Column 2 ser #, Column 3 Item
[TABLE="width: 372"]
<tbody>[TR]
[TD="width: 100"]UID #
[/TD]
[TD="width: 93"]PKG_ID
[/TD]
[TD="width: 303"]DESCRIPTION
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]1
[/TD]
[TD="width: 93, bgcolor: transparent"]BOXRBATTERY
[/TD]
[TD="width: 303, bgcolor: transparent"]BATTERY STORAGE RM
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]1
[/TD]
[TD="width: 93, bgcolor: transparent"]C115529117
[/TD]
[TD="width: 303, bgcolor: transparent"]BATTERY (K)
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]1
[/TD]
[TD="width: 93, bgcolor: transparent"]C082732718
[/TD]
[TD="width: 303, bgcolor: transparent"]BATTERY (4)
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]1
[/TD]
[TD="width: 93, bgcolor: transparent"]C115529133
[/TD]
[TD="width: 303, bgcolor: transparent"]BATTERY (B)
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]1
[/TD]
[TD="width: 93, bgcolor: transparent"]C115529164
[/TD]
[TD="width: 303, bgcolor: transparent"]BATTERY (3)
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"][/TD]
[TD="width: 93, bgcolor: transparent"][/TD]
[TD="width: 303, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]2
[/TD]
[TD="width: 93, bgcolor: transparent"]9480968
[/TD]
[TD="width: 303, bgcolor: transparent"]TRUCK
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]2
[/TD]
[TD="width: 93, bgcolor: transparent"]PO9480968
[/TD]
[TD="width: 303, bgcolor: transparent"]RADIO
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"][/TD]
[TD="width: 93, bgcolor: transparent"][/TD]
[TD="width: 303, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]3
[/TD]
[TD="width: 93, bgcolor: transparent"]9480967
[/TD]
[TD="width: 303, bgcolor: transparent"]TRUCK,UTILITY
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]3
[/TD]
[TD="width: 93, bgcolor: transparent"]PO9480967
[/TD]
[TD="width: 303, bgcolor: transparent"]RADIO
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"][/TD]
[TD="width: 93, bgcolor: transparent"][/TD]
[TD="width: 303, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]4
[/TD]
[TD="width: 93, bgcolor: transparent"]9480965
[/TD]
[TD="width: 303, bgcolor: transparent"]TRUCK
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]4
[/TD]
[TD="width: 93, bgcolor: transparent"]PO9480965
[/TD]
[TD="width: 303, bgcolor: transparent"]RADIO
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]4
[/TD]
[TD="width: 93, bgcolor: transparent"]5127431
[/TD]
[TD="width: 303, bgcolor: transparent"]FLOODLIGHT
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]4
[/TD]
[TD="width: 93, bgcolor: transparent"]5127809
[/TD]
[TD="width: 303, bgcolor: transparent"]GENERATOR
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"][/TD]
[TD="width: 93, bgcolor: transparent"][/TD]
[TD="width: 303, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]5
[/TD]
[TD="width: 93, bgcolor: transparent"]9480963
[/TD]
[TD="width: 303, bgcolor: transparent"]TRUCK
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]5
[/TD]
[TD="width: 93, bgcolor: transparent"]PO9480963
[/TD]
[TD="width: 303, bgcolor: transparent"]RADIO
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"][/TD]
[TD="width: 93, bgcolor: transparent"][/TD]
[TD="width: 303, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]6
[/TD]
[TD="width: 93, bgcolor: transparent"]3460954
[/TD]
[TD="width: 303, bgcolor: transparent"]TRUCK
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]6
[/TD]
[TD="width: 93, bgcolor: transparent"]PO9480954
[/TD]
[TD="width: 303, bgcolor: transparent"]RADIO
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]6
[/TD]
[TD="width: 93, bgcolor: transparent"]9504639
[/TD]
[TD="width: 303, bgcolor: transparent"]CLEANER,STEAM
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"][/TD]
[TD="width: 93, bgcolor: transparent"][/TD]
[TD="width: 303, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]7
[/TD]
[TD="width: 93, bgcolor: transparent"]6770953
[/TD]
[TD="width: 303, bgcolor: transparent"]TRUCK
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]7
[/TD]
[TD="width: 93, bgcolor: transparent"]PO9480953
[/TD]
[TD="width: 303, bgcolor: transparent"]RADIO
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]7
[/TD]
[TD="width: 93, bgcolor: transparent"]5126126
[/TD]
[TD="width: 303, bgcolor: transparent"]FLOODLIGHT
[/TD]
[/TR]
[TR]
[TD="width: 100, bgcolor: transparent"]7
[/TD]
[TD="width: 93, bgcolor: transparent"]5127159
[/TD]
[TD="width: 303, bgcolor: transparent"]GENERATOR
[/TD]
[/TR]
</tbody>[/TABLE]
Last edited: