Filter result from two columns through formula

[Vishaal]

HI, we want to filter data from two column to one, here are two column, column A and B, there are other data also but we want all the data from Column A and B to in one column with removing all the blank rows, you can check the result sheet

query sheet

Barc	Second	fdff
		test 565456
		test25415
SQ352		45dfdsfds
SQ353		fffds4555
SQ354		fjjfds55
	SQ354 - 1	dsfsf
SQ353		sf
SQ354		sf
	SQ354 - 2	sf
		f
		sf

result sheet

Barc
SQ352
SQ353
SQ354
SQ354 - 1
SQ353
SQ354
SQ354 - 2

I have posted it earlier also, and got vba code, but i want excel formula filter or any other
previous post Filter result from two columns

 

[kweaver]

Why wouldn't it be A2&B2 filled down or do you need the empty rows not to show (if so, what about filtering that D column to not show the blanks?)?

051923 Sum Spreadsheet.xlsm
	A	B	C	D
1	Barc	Second	fdff	Combined
4	SQ352		45dfdsfds	SQ352
5	SQ353		fffds4555	SQ353
6	SQ354		fjjfds55	SQ354
7		SQ354 - 1	dsfsf	SQ354 - 1
8	SQ353		sf	SQ353
9	SQ354		sf	SQ354
10		SQ354 - 2	sf	SQ354 - 2
Sheet3

Cell Formulas
Range	Formula
D4:D10	D4	=A4&B4

 

[Vishaal]

thanks kweaver, we are importing the data on another sheet and don't want blank rows,

we want the imported result as shown in result sheet

thanks

 

[Vishaal]

thanks kweaver, we are importing the data on another sheet and don't want blank rows,

we want the imported result as shown in result sheet

thanks

Kindly check and provide the Excel formula

 

[Fluff]

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.