Create Rows based on cell value

[spishowtime]

Hi,

Kindly help for formulas to create rows based on cell value.

Thank you!

[LeoTaxi]

Result in Column C

Please Login or Register  to view this content.

Kind regards
Leo

[spishowtime]

Thanks Leo, but the output should be whats indicated on column E and column F, the only given data is column A B C.

[LeoTaxi]

In E2

Please Login or Register  to view this content.

In F2

Please Login or Register  to view this content.

and copy down

Kind regards
Leo

[spishowtime]

Thanks LeoTaxi! the only problem i have now is when the column C id is not the same as column A

[canapone]

Hi All,

if you could use an helper column...(sorry I'm at zero level with VBA)

In D2

Please Login or Register  to view this content.

to be copied in D2:D4

In E2 to be confirmed with control+shift+enter before to be copied down:

Please Login or Register  to view this content.

in F2 and below

Please Login or Register  to view this content.

Regards

[canapone]

Hi again

you could skip the helper column.

In E2 to be confirmed with control+shift+enter

Please Login or Register  to view this content.

In F2 (again)

Please Login or Register  to view this content.

Hope that helps

[LeoTaxi]

Or

Please Login or Register  to view this content.

Cheers
Leo

[spishowtime]

Thanks guys both are working.

[canapone]

Hi,

thanks for sharing kind feedback.

Regards