Hi all,
Is there a way to reshape by individual ID with another ID (household ID) as a variable, as below? I suppose the other option is to reshape the data by the household ID variable but thought I'd check first if there is way around this. Thanks in advance.

Array

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input long idauniq int(hhidw1 hhidw2 hhidw3 hhidw4 hhidw5 hhidw6 hhidw7 hhidw8) long hhidw9
100001 .     .     .     . 11052     .     .     .      .
100001 .     . 15553     .     .     .     .     .      .
100001 .     .     .     .     .     . 15231     .      .
100001 .     .     . 17241     .     .     .     .      .
100001 . 11870     .     .     .     .     .     .      .
100005 .     .     .     .     .     .     .     . 114190
100005 .     .     .     . 13327     .     .     .      .
100006 .     .     . 14156     .     .     .     .      .
100006 .     .     .     .     . 10656     .     .      .
100006 .     .     .     . 14253     .     .     .      .
100007 .     .     .     .     . 15127     .     .      .
100007 .     .     .     . 16347     .     .     .      .
100007 .     . 14930     .     .     .     .     .      .
100007 .     .     .     .     .     .     .     . 113179
100007 . 12585     .     .     .     .     .     .      .
100007 .     .     .     .     .     . 15750     .      .
100007 .     .     .     .     .     .     . 11312      .
100007 .     .     . 16165     .     .     .     .      .
100009 .     .     . 11245     .     .     .     .      .
100009 .     .     .     .     .     .     .     . 107657
100009 .     .     .     .     . 11311     .     .      .
100009 .     .     .     . 10024     .     .     .      .
100009 .     . 13922     .     .     .     .     .      .
100009 .     .     .     .     .     . 11477     .      .
100010 .     .     . 14772     .     .     .     .      .
100012 .     .     .     .     .     .     .     . 106459
100012 .     .     . 12375     .     .     .     .      .
100012 .     .     .     . 15867     .     .     .      .
100012 .     .     .     .     .     .     . 12622      .
100012 .     . 13218     .     .     .     .     .      .
100016 .     .     . 14710     .     .     .     .      .
100016 .     . 14068     .     .     .     .     .      .
100018 .     . 13675     .     .     .     .     .      .
100018 . 13744     .     .     .     .     .     .      .
100021 . 13882     .     .     .     .     .     .      .
100021 .     .     .     .     . 14374     .     .      .
100021 .     .     .     . 10692     .     .     .      .
100021 .     . 13043     .     .     .     .     .      .
100023 .     .     .     .     . 14598     .     .      .
100023 .     .     .     . 10485     .     .     .      .
100023 .     .     .     .     .     .     . 10592      .
100023 .     .     .     .     .     . 11595     .      .
100023 .     .     .     .     .     .     .     . 105225
100024 .     .     . 17260     .     .     .     .      .
100024 .     .     .     . 13368     .     .     .      .
100024 .     . 15331     .     .     .     .     .      .
100025 .     .     .     . 15828     .     .     .      .
100025 .     .     . 14783     .     .     .     .      .
100025 .     .     .     .     .     .     .     . 113214
100025 .     .     .     .     . 10153     .     .      .
end
------------------ copy up to and including the previous l

Many thanks
Karen