Not all messages are displayed:
show all messages (155 of them)
My biggest gripe with Excel is that I have to use the F2 key to get to the formula bar. Like, who the hell finds it comfortable to use the Function keys?!
― Mr. Snrub, Friday, 6 September 2019 19:05 (four years ago) link
two weeks pass...
OK, I have a problem that's been driving me nuts for a while. I have two columns of data, and the rows are groups. It's like this:
Col A. Col B.
person 1 | keyword 1
person 1 | keyword 2
person 1 | keyword 3
person 2 | keyword 1
person 3 | keyword 1
person 3 | keyword 3
I want to eliminate the duplicate rows and put each value in column 2 in it's own column, like this:
Person 1 | keyword 1 | keyword 2 | keyword 3
Person 2 | keyword 1 | |
Person 3 | keyword 1 | keyword 3 |
There's too much data for me to just copy/paste groups of rows and transpose them.
I've tried a pivot table, but that doesn't get me the result I need. It puts all the values of column B into a single row of labels at the top. I've tried various arcane formulae, but nothing seems to work.
fffffffffuuuuuuuuuccccccccccccckkkkkkkkkkkkk
― icy bike chain rain (zchyrs), Wednesday, 25 September 2019 21:05 (four years ago) link
or? if you search for 'vlookup that returns multiple values' there are some different methods that returns exact match results in its own cell.
― Yerac, Thursday, 26 September 2019 01:45 (four years ago) link
'vlookup that returns multiple values' was definitely the right thing to search! Many thanks, Yerac. Tinkering with the formula here did the trick.
― icy bike chain rain (zchyrs), Thursday, 26 September 2019 14:00 (four years ago) link