You were almost there. A small adaption to your code snippet yields the desired result:awk '{n=split($1,s,"|");for (i=1;i<=n;i++) {if (s[i]) {$1=s[i];print }}}' OFS="\t" file
store_id Age_21_25 ...
Your spec is a bit inconsistent, a delimiter is missing between "store" and "Dollar" in the header; and also the delimiter count at line end differs between header and data lines. However, tryawk...