Hi Community,
I'm not sure how to ask this, but I have a list of 1st values which repeat.
And a list of corresponding 2nd values.
I need to amalgamate the 1st values and count them, then transpose the list of 2nd values for the 1st values.
I'm sure there is a better way of explaining, but attached is a sheet. Column I is manually created, but it contains the data as I need it.
Hopefully I have made it clear enough within the file.
Hi. In I2, copied across and down:
=IFERROR(INDEX($B:$B,AGGREGATE(15,6,ROW($B$2:$B$13)/($A$2:$A$13=$G2),COLUMNS($I:I))),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Your ability to understand the problem is only bested by your ability to solve!
Many thanks.
Hi, to both!
Another way... with Excel 365:
[I2] : =TRANSPOSE(FILTER(B$2:B$13,A$2:A$13=G2))
And Drag it down. Blessings!
You're welcome and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks