extract data from one column to another column

[lakody]

Hi all,In first column i have :

12-dec-16 <tbody> </tbody>

NL86RABertert4534 <tbody> </tbody>

BV NAT. PUBLICITEITSBUR. <tbody> </tbody>

NL86 34534534534 <tbody> </tbody>

-240,44 <tbody> </tbody>

9-dec-16 <tbody> </tbody>

NL63ABNrtyrtyrty <tbody> </tbody>

FAMED BV <tbody> </tbody>

Nlrtyrtyrtyr <tbody> </tbody>

2854,23 <tbody> </tbody>

7-dec-16 <tbody> </tbody>

273 Lidl <tbody> </tbody>

-15,28 <tbody> </tbody>

5-dec-16 <tbody> </tbody>

NL63ABN <tbody> </tbody>

FAMED BV <tbody> </tbody>

NL63 ABN <tbody> </tbody>

3297,89 <tbody> </tbody>

1-dec-16 <tbody> </tbody>

NL25A <tbody> </tbody>

P VAA DERY EIJKER <tbody> </tbody>

NL25 A <tbody> </tbody>

-1323,5 <tbody> </tbody>

30-nov-16 <tbody> </tbody>

NL50A <tbody> </tbody> <tbody> </tbody>

MEEUSD RADEUREN

-269,89 <tbody> </tbody>

...

<tbody>
</tbody>

I would like to extract like this:

12-dec-16 <tbody> </tbody>	NL86RABertert4534 <tbody> </tbody>	BV NAT. PUBLICITEITSBUR. <tbody> </tbody>	NL86 34534534534 <tbody> </tbody>	-240,44 <tbody> </tbody>
9-dec-16 <tbody> </tbody>	NL63ABNrtyrtyrty <tbody> </tbody>	FAMED BV <tbody> </tbody>	Nlrtyrtyrtyr <tbody> </tbody>	2854,23 <tbody> </tbody> <tbody> </tbody>
7-dec-16 <tbody> </tbody>		273 Lidl <tbody> </tbody>		-15,28 <tbody> </tbody>
5-dec-16 <tbody> </tbody>	NL63ABN <tbody> </tbody>	FAMED BV <tbody> </tbody>	NL63 ABN <tbody> </tbody>	3297,89 <tbody> </tbody>
1-dec-16 <tbody> </tbody>	NL25A <tbody> </tbody>	P VAA DERY EIJKER <tbody> </tbody>	NL25 A <tbody> </tbody>	-1323,5 <tbody> </tbody>
30-nov-16 <tbody> </tbody>	NL50A <tbody> </tbody>	MEEUSD RADEUREN <tbody> </tbody>		-269,89 <tbody> </tbody>

<tbody>
</tbody>

thanks a lot, Mehdi

 

[CyrusTheVirus]

Try the below formula in cell B1 and drag down and over

=IF(ISBLANK(INDIRECT("A"&(COLUMNS($B$1:B1)+(ROWS($B$1:B1)*5-5)))),"",INDIRECT("A"&(COLUMNS($B$1:B1)+(ROWS($B$1:B1)*5-5))))

 

[lakody]

Try the below formula in cell B1 and drag down and over

=IF(ISBLANK(INDIRECT("A"&(COLUMNS($B$1:B1)+(ROWS($B$1:B1)*5-5)))),"",INDIRECT("A"&(COLUMNS($B$1:B1)+(ROWS($B$1:B1)*5-5))))

Thank you,extraction from the first 2 rows is perfect but from 3th row is not.

 

[CyrusTheVirus]

I see. Yeah, sorry, I won't be able to help you with that situation.