Issue transposing values based on matching unique identifiers

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.

Post Flair (click to view more posts with a particular flair)

solved

Post Body

I'm having an issue with a formula designed to transpose associated values based on matching unique identifiers across two sheets in Excel. Here's a summary of my set up
Sheet1 has a column of unique values (Column A).

Sheet2 has a column with some of these values repeating (Column A) and associated values next to them (Column B).

I'm trying to use the unique values from Sheet1 to gather and transpose the associated values from Sheet2 onto parallel cells in Sheet1.

The formula im using is:
=TRANSPOSE(FILTER(Sheet2!B:B, Sheet2!A:A=A1))

this formula returns an empty array, and I can't figure out why. Any help would be appreciated!

Author

Account Strength

80%

Account Age

4 years

Verified Email

Yes

Verified Flair

Total Karma

391

Link Karma

391

Comment Karma

n/a

Profile updated: 5 days ago

Posts updated: 3 weeks ago

barmeloxannthony

Subreddit

r/excel

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 9 months ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/excel/comme...