google spreadsheet - Transposing Items with Prices to Separate Section -

in google sheets i'm trying to transpose list of items , prices (displayed in rows) automatically display in adjacent section columns. problem need include items have prices.

here's demo image of i'm trying do. intended result:

i have list of items prices in "plan" section items , prices listed.

i need transpose data rows items have price , display items , corresponding prices in "details" section.

here's mock-up of have working: current version:

the problem it's listing items whether have price or not . listing items , prices in unrelated columns.

currently using named ranges category1_items , category2_items , price_1 , price_2 in following formulas:

=arrayformula(split(join("~~~",category1_items,category2_items,),"~~~")) =arrayformula(split(join("~~~",price_1,price_2,),"~~~")) 

i know not close need, it's close have been able far i'm of newbie sheets.

i'd achieve without resorting scripts if @ possible!

there might subtle details omitted prevent working, perhaps try:

=transpose(query({category1_items,price_1;category2_items,price_2},"select * col2 != ''",0))

note, if prices numerical values (rather strings in example), need change != '' is not null.