This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
Creating duplicates (based on input values) with IDs
My previous post: https://www.reddit.com/r/excel/comments/1i2y36h/comment/m7zh3ha/
So I got quite far with what I need overall but I need a change! If someone can help me!!
I have the following data. Created from
FLOOR NUMBER:
=TRANSPOSE(TEXTSPLIT(TEXTJOIN(" ", TRUE, LAMBDA(x,REPT($B$2:$D$2&" ",x))(B3:D5))," ",,TRUE))
UNIQUE NUMBER:
=SEQUENCE(SUM($B$3:$D$5),1)
DOOR LOCATION:
=TRANSPOSE(TEXTSPLIT(TEXTJOIN(" ",TRUE, REPT(A3:A5&" ",BYROW(B3:D5,LAMBDA(x,SUM(x)))))," ",,TRUE))
I now need to change my Unique number to only show a sequence for numbers on a specific floor!!
So the below output needs to read
Floor No - Unique No
00 - 01
00 - 02
01 - 01
01 - 02
02 - 01
00 - 03
01 - 03
01 - 04
Etc.
| Input | Output | ||||||
|---|---|---|---|---|---|---|---|
| Location | Ground | First | Second | Floor No | Unique Number | Door Location | |
| Corridor | 2 | 2 | 1 | 00 | 01 | Â Corridor | |
| Drying | 1 | 2 | 1 | 00 | 02 | Â Corridor | |
| Test | 2 | 1 | 1 | 01 | 03 | Â Corridor | |
| 01 | 04 | Â Corridor | |||||
| 02 | 05 | Â Corridor | |||||
| 00 | 06 | Drying Room | |||||
| 01 | 07 | Drying Room | |||||
| 01 | 08 | Drying Room | |||||
| 02 | 09 | Drying Room | |||||
| 00 | 10 | Test | |||||
| 00 | 11 | Test | |||||
| 01 | 12 | Test | |||||
| 02 | 13 | Test | |||||
Post Details
- Posted
- 2 weeks ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/excel/comme...