If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below. If you don't like Google AdSense in the posts, register or log in above.

Lookup Data & Return Same Row But Different Column

I'll do my best to explain what situation I have and what I need to be done.
I have an excel book containing a database of citations of articles, with information such as Title, Author, Year, Abstract etc.
In the database I have multiple tabs of different categories, and there are duplicates across tabs.

I have used SPSS to aggregate the different categories into one database, merging duplicates and tagging each article with all the different categories it previously appeared in. However the problem is when creating the excel book from SPSS for some reason the string length for each field was limited to 255 characters. So the abstracts in the aggregated excel database are cut short.

Ozgrid is Not Associated With Microsoft. Ozgrid Retains the Rights to ALL Posts and Threads

All times are GMT+8. This page was generated at 1 minute ago.

Working...

X

We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our Privacy Policy.

By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.