If statement is false, skip to next row

[tbraden]

My goal is to get data that automatically updates from a different sheet. The data contains values from January-December. I'm using an IF statement to extract the data from the previous sheet, and my formula in Sheet2 is as follows.

=IF('Sheet1'!A1=1,'Sheet1'!B1,"") For January Data
=IF('Sheet1'!A1=2,'Sheet1'!B1,"") For February Data

All of the data in sheet 1 is oriented vertically, like this: (January = Month 1, February = Month 2, etc.)
Month Value
1 12
1 15
1 27
1 56
2 45
2 95
2 28

This formula extracts the data that I want it to for January, however the February column in Sheet2 is blank until it is past the end of the January data. I do not want to display all of these blank cells at the top where the IF statement is false I'm not sure how to write a formula such that it will skip to the next row of Sheet1 when the statement is false. I appreciate any help, all I want to do is move the February data in Sheet2 up so that it will line up with the January data.

My output in sheet 2 looks like this:

Jan Feb
12
15
27
56
45
95
28

[Richard Buttrey]

Hi and welcome to the forum

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

I suspect you may want the two column list distributed across a multi column list where the columns are for each month but that's not apparent from your description

[tbraden]

I attached a smaller version of my spreadsheet as an example. In the results tab, I'm trying to get the February data moved to the top

[AliGW]

Do you have Power Query (Get & Transform on the Data ribbon) in your version of Excel? If so, your summary table can be created easily.